OpenEdge Data Management:<br />Database Administration PROMON User Control option

PROMON User Control option

Displays information for each database process. Figure 19–2 shows an example of this option’s output.

User Control Usr Name Type Wait Trans PID Sem Srv Login Time 0 BROK 0 0 3989 3 0 12/20/92 15:38 1 sue SELF 0 3145 6356 4 0 12/21/92 16:00 2 dave SELF DB 0 6943 5 0 12/22/92 14:45 3 SERV 0 0 6968 6 0 12/22/92 15:00 4 mary REMC REC 3267 7007 7 3 12/22/92 15:28 5 bill REMC 0 0 7034 9 3 12/22/92 16:01 6 MON 0 0 7123 9 0 12/22/92 16:36 The DB holder is user -1. The MT holder is user -1. RETUN - repeat, U - continue uninterrupted, Q - quit

User Control 
Usr   Name     Type      Wait    Trans    PID    Sem   Srv   Login     Time 
0              BROK        0         0    3989   3     0     12/20/92  15:38 
1     sue      SELF        0      3145    6356   4     0     12/21/92  16:00 
2     dave     SELF       DB         0    6943   5     0     12/22/92  14:45 
3              SERV        0         0    6968   6     0     12/22/92  15:00 
4     mary     REMC      REC      3267    7007   7     3     12/22/92  15:28 
5     bill     REMC        0         0    7034   9     3     12/22/92  16:01 
6              MON         0         0    7123   9     0     12/22/92  16:36 
The DB holder is user -1. The MT holder is user -1. 
RETUN - repeat, U - continue uninterrupted, Q - quit

Figure 19–2: Sample output for PROMON User Control option

Usr

User numbers are assigned sequentially to database processes as they are started. The broker process is always user (0).


Name

The user name for end-user (client) processes.


Type

Table 19–1 lists the distinct types of database processes that can appear in the Type field.

Table 19–1: Process type values
Value	Process type
AIMD	After-image file management utility daemon.
AIW	After-image writer (AIW) process.
APW	Asynchronous page writer.
AUDA	Audit archive utility.
AUDL	Audit load utility.
BAT	Batch user.
BIND	Binary dump utility.
BINL	Binary load utility.
BIW	Before-image writer.
BKUP	Online backup.
BROK	Broker process.
FMA	Fathom™ Management Monitor.
IACT	Index activate utility.
IDXC	Index compact utility.
IDXF	Index fix utility.
IDXM	Index move utility.
MON	Monitor process.
PSA	PROSTRCT ADD utility.
QUIE	PROQUIET utility.
REMC	Remote client.
RFUT	RFUTIL utility.
RPLA	Fathom Replication Site Replication Agent.
RPLE	Fathom Replication Site Replication online enable.
RPLS	Fathom Replication Site Replication Server.
RPLT	Fathom Replication Site Replication Transition.
RPLU	Fathom Replication Site Replication Utilities.
SELF	Self-service client.
SERV	Remote-user server.
SHUT	Database shutdown process.
SQSC	SQLSCHEMA utility.
SQDP	SQLDUMP utility.
SQLD	SQLLOAD utility.
SQSV	SQL server.
TBLM	Table move utility.
WDOG	Watchdog.


Wait

Indicates that a process is waiting for a lock or latch. Table 19–2 lists common values and resource or event the process is waiting for.

Table 19–2: Possible wait column values
Value	Description
Lock waits
REC	Row (record) lock.
IX	Index lock.
SCHE	Schema lock.
TRAN	Transaction commit.
TXB	Transaction end update mode lock.
TXE	Transaction end commit mode lock.
TXS	Transaction end share lock.
TXX	Transaction end exclusive lock.
Resource waits
AIRD	After-image buffer read from disk.
AIWR	After-image buffer write to disk.
BIRD	Before-image buffer read from disk.
BIWR	Before-image buffer write to disk.
BKEX	Exclusive lock on database buffer.
BKSH	Share lock on database buffer.
BKSI	Share lock with intent to update on database buffer.
BUFF	Shared buffer.
DB	Database server.
DBBK	Database buffer being backed up.
DBRD	Database buffer read from disk.
DBWR	Database buffer write to disk.
DEAD	Process is waiting to be removed from the process list.¹
RGET	Row get lock.
SRPL	Replication agent acknowledgement.
Latch waits
AIB	After-image buffer latch.
BFP	Buffer pool latch.
BHT	Buffer pool hash table latch.
BUF	Buffer pool buffer latch.
CPQ	Checkpoint queue latch.
DLC	Index delete chain.
GST	Global storage pool latch.
IXD	Index delete chain latch.
LKF	Lock table free chain latch.
LKP	Lock table purge chain latch.
LKT	Lock table latch.
LRS	Secondary LRU chain (not currently implemented).
LRU	Buffer pool LRU chain latch.
MTX	Log space allocation latch.
PWQ	Page writer queue latch.
SCH	Shared schema cache latch.
SEQ	Sequence cache latch.
TXQ	Transaction queue latch.
TXT	Transaction table latch.
USR	User table latch.

¹Seen when a process is terminated with the UNIX kill-9 command

You may also see the following values listed in the Wait column:

BF2

BF3

BF4

BIB

LRI

LRX

The previous values are for short-duration (micro- to milliseconds) latches used internally by the OpenEdge RDBMS.


Trans

Transaction (task) number, if one is active. After the broker starts, numbers are assigned sequentially to each transaction that accesses the database.

PID

The process ID as assigned by the operating system. The PID column typically displays (0) for remote clients.

Sem

The number of the semaphore the process is using. Each process uses exactly one semaphore. The database engine uses two semaphores (numbers 1 and 2) internally and assigns the remaining semaphores one at a time (starting with the broker) as database processes log in.

Srv

For remote clients (REMC), the user number of the server the client runs against.


Login

The date the process started.


Time

The time the process started.